
use T2Logging;
	
--*************************************************************
--Created By: trooks
--Name: Drop All Foreign Keys
--Database: T2Logging
--Created Date: 02/15/2013 20:07:08
--*************************************************************
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[fk_dbo_Tenant_dbo_Application]') AND parent_object_id = OBJECT_ID(N'[dbo].[Application]'))
ALTER TABLE [dbo].[Application] DROP CONSTRAINT [fk_dbo_Tenant_dbo_Application]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[fk_dbo_Application_dbo_Log]') AND parent_object_id = OBJECT_ID(N'[dbo].[Log]'))
ALTER TABLE [dbo].[Log] DROP CONSTRAINT [fk_dbo_Application_dbo_Log]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[fk_dbo_LogCategory_dbo_Log]') AND parent_object_id = OBJECT_ID(N'[dbo].[Log]'))
ALTER TABLE [dbo].[Log] DROP CONSTRAINT [fk_dbo_LogCategory_dbo_Log]
GO
